TIPOARTICULO

"192.168.0.1:sipop"

TIPOARTICULO

Descriptions

TIPO DE ARTICULOS EN BODEGA

Fields

Name	Data type	Description
ID_TIPO_ARTICULO	CHAR (3)	ID de tipo de articulo
NOMBRE	CHAR (30)	Nombre del tipo de producto o articulo
DESCRIPCION	CHAR (30)

Triggers

There are no triggers for table TIPOARTICULO

Indices

There are no indices for table TIPOARTICULO

References

There are no references for table TIPOARTICULO

Referenced

Table	Foreign Key	Fields	FK Fields	DEL Rule	UPD Rule
INVENTARIO	INTEG_270	TIPO_ARTICULO	ID_TIPO_ARTICULO	RESTRICT	RESTRICT
INVENTARIOHQ	INTEG_215	TIPO_ARTICULO	ID_TIPO_ARTICULO	RESTRICT	RESTRICT

Definition


CREATE TABLE TIPOARTICULO (
    ID_TIPO_ARTICULO CHAR (3) CHARACTER SET NONE NOT NULL COLLATE NONE,
    NOMBRE CHAR (30) CHARACTER SET NONE NOT NULL COLLATE NONE,
    DESCRIPCION CHAR (30) CHARACTER SET NONE NOT NULL COLLATE NONE);

ALTER TABLE TIPOARTICULO ADD PRIMARY KEY (ID_TIPO_ARTICULO);

This file was generated with EMS InterBase/FireBird Manager (www.ibmanager.com) at 09/06/2005 05:52 p.m.